home *** CD-ROM | disk | FTP | other *** search
/ Mastering Internet Develo…oft ActiveX Technologies / Mastering Internet Development with ActiveX (1996)(Microsoft).iso / labs / lab07.2 / solution / rgsales.idc < prev    next >
Text File  |  1996-07-16  |  341b  |  10 lines
  1. Datasource: WebMainSt
  2. Template: RgSales.htx
  3. SQLStatement:
  4. +SELECT orders.OrderID, orders.OrderDate, Sum([Quantity]* [UnitPrice]) AS OrderTotal
  5. + FROM Orders, [Order Details]
  6. + WHERE Orders.OrderID = [Order Details].OrderID 
  7. + AND (Orders.OrderDate Between #%StartDate%# and #%EndDate%#)
  8. + GROUP BY orders.OrderID, Orders.OrderDate
  9.  
  10.